。Spreadsheet Operations

Powerful spreadsheets may be used to view, sort and edit the input data and results. The spreadsheets and model views are synchronized, unless you turn this feature off in the Application Settings on the Tools Menu. As you edit a model graphically the spreadsheets are automatically updated and as you make changes in the spreadsheets the model views reflect these changes immediately.

The input data may be accessed from the Spreadsheets Menu. You may edit the data or you can add new data. You can also paste data from another application directly into the spreadsheet via the Windows clipboard. Any changes made to the input spreadsheets may also be viewed graphically.

After solving the model, results are recorded in spreadsheets for browsing. These spreadsheets may be accessed from the Results Menu. You may sort the results in order to find maximums and exclude data that is not important. You may also copy this data to the Windows clipboard and use it in another application.

For additional advice on this topic, please see the RISA Tips & Tricks webpage at risa.com/post/support. Type in Search keywords: Advanced Spreadsheet.

What do you want to know?

What special spreadsheet functions are available?
What keyboard commands are available in the spreadsheets?

Moving and Scrolling

To move between cells in a spreadsheet, click any cell or use the keyboard arrow keys. When you move to a cell it becomes the active cell. To see a different area of the spreadsheet use the vertical scroll bars on the right side of the spreadsheet.

To Scroll	Do This
One row up or down	Click the arrows on the vertical scroll bar.
One column left or right	Click the arrows on the horizontal scroll bar.
One page up or down	Click above or below the scroll box in the vertical scroll bar.
One page left or right	Click to the left or right of the scroll box in the horizontal scroll bar.
A large distance	Drag the scroll box to the approximate relative position.

Note:

The size of a scroll box indicates the proportional amount of the spreadsheet that is visible. The position of a scroll box indicates the current location relative to the spreadsheet.
The mouse wheel is also an excellent tool for scrolling up and down in spreadsheets or graphics. Roll the wheel or click and drag to move around.

Spreadsheet Keyboard Commands

The following keyboard commands are available:

Key	Function
Arrow Keys	Move the active cell one location
TAB	Move right one cell
ENTER	Move to the first column of the next line. Adds new line if necessary.
PAGE UP	Move the active cell one full page up.
PAGE DOWN	Move the active cell one full page down.
HOME	Move to the first line of the spreadsheet.
END	Move to the last line of the spreadsheet.
F3	Insert new line below current line.
F4	Delete current line.
F8	Insert new line below current line and repeat the current values in the new line.

Selecting Spreadsheet Cells

Before you can carry out commands or tasks in a spreadsheet, you must select the cells that you want to work with.

To Select	Do This
A single cell	Click the cell, or press the arrow keys to move to the cell.
A range of cells	Click the first cell of the range, and then drag to the last cell.
An entire row	Click the row heading.
An entire column	Click the column heading.
Adjacent rows or columns	Drag across the row or column headings

Note:

To cancel a selection of cells, click any single cell in the spreadsheet.

Undoing Operations

RISA-2D provides you with virtually unlimited Undo capability so that you may easily correct mistakes or just back up to try different possibilities. Simply click the Undo button as many times as you wish to go back a step. The model view and the spreadsheets will visually display the "undoing". Remember that graphic edits are undone as well.

Redoing Operations

RISA-2D provides you with virtually unlimited Redo capability so that you may reapply actions that were previously undone. Simply click the Redo button as many times as the Undo button was used just prior. The model view and the spreadsheets will visually display the "redoing". Remember that graphic edits are redone as well.

Editing Spreadsheets

The spreadsheets have been specifically developed for the input and editing of structural models. There are many ways to edit the spreadsheets allowing you to quickly build your model. You may copy and move data from other locations or other files. You may also fill large blocks of cells automatically and perform math on these cells.

To Change Basic Load Cases in a Load Spreadsheets

Use the drop down load list on the window toolbar to control the basic load case in a load spreadsheet.

To Fill Selected Cells

Select the cells you wish to fill.
Click the Block Fill button.
Type the value you wish to apply.
Click OK.

To Perform Math on Selected Cells

Select the desired cells.
Click the Block Math button.
Specify the value and the operation you wish to apply.
Click OK.

To Cancel or Undo Editing

To cancel an entry before you press ENTER, press ESC.
To undo a completed entry, click the Undo button.

To Edit Cell Contents

Click the cell that contains the data you want to edit.
Make any changes to the cell contents.
To enter your changes, press ENTER.
To cancel your changes, press ESC.

Note

To replace the contents of a cell, click on the cell and type the new entry.
To edit the contents of a cell, double-click on the cell and use the arrow keys to locate the cursor and perform the edit.

Inserting, Deleting and Clearing Cells

To insert cells you must insert an entire row. When you delete cells you must delete an entire row. The row is removed from the worksheet and shifts the lower cells to fill the space. When you clear cells, you remove the cell contents but leave the blank cells on the spreadsheet.

To Insert Rows

Click a cell in the row immediately above where you want the new row.
To insert a blank line, click the Insert New Line button.
To have the values of the current line copied in the new line, click the Repeat Current Line button.

To Clear Cell Contents

Select the cells, rows, or columns you want to clear and press the DELETE key.

To Delete Rows

Select the rows you want to delete.
Click the Delete Marked Lines button and the lower cells will shift up to fill the space.

Note

Some spreadsheets do not allow you to delete lines. For example the Member Design spreadsheet has one line for each member defined. You may leave these lines blank but may not delete them.

Moving and Copying Cell Contents

Standard Windows cut, copy and paste functions are fully supported. By using the clipboard you may move or copy any spreadsheet data to another location in the same spreadsheet, or to another spreadsheet (provided it fits). You may also copy data to or from another model or any other application that supports copy and paste such as a word processor or spreadsheet.

To Move or Copy Cells

Select the cells you want to move or copy.
To copy the cells select Copy on the Edit Menu.

To move cells select Cut on the Edit Menu.

Click on the cell you wish to place the data in and click the Paste button.

To Move or Copy Cells between Existing Cells

Select the cells you want to move or copy.
To copy the cells selectCopy on the Edit Menu.

To move cells select Cut on the Edit Menu.

Select a cell on the row above where you want to place the data.
Click the Insert New Line button for each new line that is needed.
Click on the upper left cell you wish to place the data in and click the Paste button.

To Move or Copy Cells to Another File

Select the cells you want to move or copy.
To copy the cells selectCopy on the Edit Menu.

To move cells select Cut on the Edit Menu.

Open the file you wish to copy the data to.
Click on the cell you wish to place the data in and click the Paste button.

Note:

Your data stays in the clipboard until you cut or copy new data. You may repeat step 4 to move or copy data to multiple locations.
When you copy information a dialog will come up asking if you want to copy the spreadsheet headers as well. This is helpful if you are copying information to a spreadsheet-type program. See the Customizing RISA topic for more information on this.

Sorting and Finding in Spreadsheets

You may sort spreadsheets by the values in most any column. Simply click in the column you wish to sort, click on the Sort button and choose the sorting method.

You may relabel the joints, members, plates, or solids after sorting them by using the options in the Tools Menu.

To locate or find a specific joint, member, or plate while in a spreadsheet, click the Find button on the Window Toolbar.

Default Spreadsheet Data

Many of the spreadsheets provide the option to save the current data as the default and every new file subsequent to the save will already have that data. This way the office standards that you might use in most of your models are already entered and available in new models. This feature is available in the following spreadsheets: Materials, Design Rules, Footings, and Load Combinations.

To save default data simply click the Save as Defaults button when you are ready and the current data in the spreadsheet will be used in each new file that you create. The data is saved for the current, active, spreadsheet only and affects no other open or closed spreadsheets.

Export to Excel Spreadsheet

For all Results spreadsheet, the program is capable of exporting them into Excel Spreadsheet.

The process is as follows:

Right Click and click Export to Excel option.
Choose if you want to export the current spreadsheet tab or all tabs.
Select Excel file name and file save location and export.

Note: The Export to Excel can also be used by clicking the button on ribbon .

Special Spreadsheet Functions

There are special functions that help you with a particular spreadsheet. For example you may generate K factors for members on the Member Design Parameters Spreadsheet. These features may be accessed on the Window Toolbar or you may right click your mouse on the spreadsheet and choose the feature on the Shortcut Menu.

Member Design Spreadsheet

Click to approximate the K factor for the current member or all of the members. See K Factors (Effective Length Factors) learn more about this feature.

Basic Load Case Spreadsheet

Click to copy loads from one basic load case to another. You may choose certain load types such as distributed loads and point loads. Once you have created a copy you can use the spreadsheet tools to quickly modify the loads.

Click to clear loads from a basic load case.

Load Combinations Spreadsheet

Click , or to solve the current load combination, batch, or envelope solutions.

You may click button to have the program generate load combinations based on a variety of Building Codes. See Generating Building Code Combinations for more information.

Selecting Items in the Model View

In certain results spreadsheets there is the capability to have elements selected graphically.

The process is as follows:

Unselect the entire model.
Open the desired results spreadsheet.
Highlight in Yellow the lines you wish to view graphically, by clicking on the number of those lines on the far left.
Click the Select Marked Lines in Current View icon .
Only those elements highlighted will be selected graphically.

Note: The inverse process can be used to Unselect Marked Lines using the .